Primary Keys & Foreign Keys

Takeaways

Primary Key

• The primary key is the unique identifier for the entire row, referring to one or more columns.
• If there are more multiple columns for the primary key, then the set of primary key columns is known as a composite key .

Foreign Key

• A primary key in another (foreign) table.
• Foreign keys are used to map relationships between tables.